	<?php	

function getStatusCodeMessage($status)
{
    // these could be stored in a .ini file and loaded
    // via parse_ini_file()... however, this will suffice
    // for an example
    $codes = Array(
        100 => 'Continue',
        101 => 'Switching Protocols',
        200 => 'OK',
        201 => 'Created',
        202 => 'Accepted',
        203 => 'Non-Authoritative Information',
        204 => 'No Content',
        205 => 'Reset Content',
        206 => 'Partial Content',
        300 => 'Multiple Choices',
        301 => 'Moved Permanently',
        302 => 'Found',
        303 => 'See Other',
        304 => 'Not Modified',
        305 => 'Use Proxy',
        306 => '(Unused)',
        307 => 'Temporary Redirect',
        400 => 'Bad Request',
        401 => 'Unauthorized',
        402 => 'Payment Required',
        403 => 'Forbidden',
        404 => 'Not Found',
        405 => 'Method Not Allowed',
        406 => 'Not Acceptable',
        407 => 'Proxy Authentication Required',
        408 => 'Request Timeout',
        409 => 'Conflict',
        410 => 'Gone',
        411 => 'Length Required',
        412 => 'Precondition Failed',
        413 => 'Request Entity Too Large',
        414 => 'Request-URI Too Long',
        415 => 'Unsupported Media Type',
        416 => 'Requested Range Not Satisfiable',
        417 => 'Expectation Failed',
        500 => 'Internal Server Error',
        501 => 'Not Implemented',
        502 => 'Bad Gateway',
        503 => 'Service Unavailable',
        504 => 'Gateway Timeout',
        505 => 'HTTP Version Not Supported'
    );
 
    return (isset($codes[$status])) ? $codes[$status] : '';
}
// Helper method to send a HTTP response code/message
function sendResponse($status = 200, $body = '', $content_type = 'text/html')
{
    $status_header = 'HTTP/1.1 ' . $status . ' ' . getStatusCodeMessage($status);
    header($status_header);
    header('Content-type: ' . $content_type);
    echo $body;
}					



class ReturnInformation {




	function insertResolution() {
	$theServer = "scc-its";

/*	
	$site = $_GET["site"];
	$room = $_GET["room"];
	$type = $_GET["type"];
	$issue = $_GET["issue"];
*/
	$username = $_POST["username"];
	$site = $_POST["site"];
	$room = $_POST["room"];
	$type = $_POST["type"];
	$issue = $_POST["issue"];


	$source = "ios";
	
	//$username = substr(strrchr($_SERVER['REMOTE_USER'], '\\'), 1);
	
	$connectionInfo = array("UID"=>"staff-ulive", "PWD"=>"readonly", "Database"=>"ITServices");
	$conn = sqlsrv_connect( $theServer, $connectionInfo);


	$query_Params = array($username, $site, $room, $type, $issue, $source);
	
	$query_InsertResolution = "exec srv_logNewIncident  ?, ?, ?, ?, ?, ?";

	$runQuery_InsertResolution = sqlsrv_query( $conn, $query_InsertResolution, $query_Params);
	
	
	/*
		srv_incidentResolvedByEmail
			@incidentReference nvarchar(20)
           ,@incidentStatus nvarchar(20)
           ,@analystUsername nvarchar(50)
           --,@analyst nvarchar(60)
           ,@resolutionComment nvarchar(max)
		   ,@resolutionSource nvarchar(50)
		
	*/
	
	
	
	
	
	//get form values
	$oldValue = "";
					if( $conn )
					/*
					{
						if ($runQuery_InsertResolution)
						{
							sendResponse(200, 'OK');
						
						}
						else
						{
							echo("query failed.\n");
							sendResponse(503, sqlsrv_errors());
							//sendResponse(503, 'SQL Connection failed');
							die(print_r(sqlsrv_errors(),true));
							
						}
					}
					*/
					if (!$runQuery_InsertResolution) {
						echo("query failed.\n");
						sendResponse(503, sqlsrv_errors());
							//sendResponse(503, 'SQL Connection failed');
						die(print_r(sqlsrv_errors(),true));
					}
					else {
						sendResponse(200, 'OK'); 
					}
	
	
	return true;
	}
}



$api = new ReturnInformation;
$api -> insertResolution();

